package qsoft.omanga.common.utils;

/**
 * 
 * @author sontt
 *
 */
public class DataConfig {
    
    /**
     * 
     */
	public static final String DATABASE_NAME = "Omanga.db";
	/**
     * 
     */
	public static final int DATABASE_VERSION = 1;
	/**
     * 
     */
	public static final String CREATE = "CREATE TABLE IF NOT EXISTS ";
	/**
     * 
     */
	public static final String PRIMARY = " INTEGER PRIMARY KEY ";
	/**
     * 
     */
	public static final String AUTOINCREMENT = " AUTOINCREMENT ";
	/**
     * 
     */
	public static final String ALL = " * ";
	/**
     * 
     */
	public static final String COMMA = " , ";
	/**
     * 
     */
	public static final String BRACKETS_LEFT = " ( ";
	/**
     * 
     */
	public static final String BRACKETS_RIGHT = " );";
	/**
     * 
     */
	public static final String TEXT = " TEXT ";
	/**
     * 
     */
	public static final String INT = " INTEGER ";
	/**
     * 
     */
	public static final String ID = "id";
	/**
     * 
     */
	public static final String MANGAID = "mangaid";
	/**
     * 
     */
	public static final String MANGA_NAME = "name";
	/**
     * 
     */
	public static final String MANGA_AUTHOR = "author";
	/**
     * 
     */
	public static final String MANGA_DESCRIPT = "descript";
	/**
     * 
     */
	public static final String TABLE_MANGA = "omanga";
	/**
     * 
     */
	public static final String CHAPTER_ID = "chapterid";
	/**
     * 
     */
	public static final String CHAPTER_MANAGA_ID = "managaid";
	/**
     * 
     */
	public static final String CHAPTER_NAME = "name";
	/**
     * 
     */
	public static final String CHAPTER_PAGE = "page";
	/**
     * 
     */
	public static final String TABLE_CHAPTER = "chapter";
	/**
     * 
     */
	public static final String CREATE_TABLE_OMANGA = CREATE + TABLE_MANGA
			+ BRACKETS_LEFT + ID + PRIMARY + AUTOINCREMENT + COMMA + MANGAID
			+ INT + COMMA + MANGA_NAME + TEXT + COMMA + MANGA_AUTHOR + TEXT
			+ COMMA + MANGA_DESCRIPT + TEXT + BRACKETS_RIGHT;
	/**
     * 
     */
	public static final String CREATE_TABLE_CHAPTER = CREATE + TABLE_CHAPTER
			+ BRACKETS_LEFT + ID + PRIMARY + AUTOINCREMENT + COMMA + CHAPTER_ID
			+ INT + COMMA + CHAPTER_NAME + TEXT + COMMA + CHAPTER_PAGE + INT
			+ BRACKETS_RIGHT;
}
